<?php

use Illuminate\Database\Migrations\Migration;

class CreateChitietkehoachTable extends Migration
{
    /**
    * Run the migrations.
    *
    * @return void
    */
    public function up()
    {
        Schema::create('chi_tiet_ke_hoach', function($table)
        {
            $table->engine='InnoDB';
            $table->increments('id')->unsigned();
            $table->text('tuan',50);
            $table->integer('id_ke_hoach')->unsigned();
            $table->integer('id_cv')->unsigned();
            $table->text('ghi_chu_cong_viec')->nullable()->default(null);
            $table->integer('id_dg')->nullable()->default(null)->unsigned();
            $table->datetime('thoi_gian_danh_gia')->nullable()->default(null);
        });
    }

    /**
    * reverse the migrations.
    *
    * @return void
    */
    public function down()
    {
        Schema::drop('chi_tiet_ke_hoach');
    }
}